package com.quanhenghe.conf;

import com.quanhenghe.info.StationInfo;

public class GetFirInsert {
	private String SQLstr;
	private String staName;
	private String staUrl;
		GetFirInsert() {
			StationInfo sInfo = new StationInfo();
			String str= sInfo.getStaInfo();
			str=str.replace("`station_id`, ", "");
			String []strbak = str.split("[,(]");

			StringBuilder sb=new StringBuilder();
			str=str.replace(strbak[37], "");
			str=str.replace(strbak[63], "NOW()");
			str=str.replace(strbak[65], "NOW()");

			strbak=str.split("[,]");
			strbak[60]="'quanhenghe'";
			strbak[62]="'quanhenghe'";
			strbak[70]="''";//防止c/uer 为空
			for(int i=0;i<strbak.length;i++) {
				sb.append(strbak[i]);
				if(i!=35&&i!=strbak.length-1) {
					sb.append(",");
				}
			}
		SQLstr=sb.toString();
	}
	public String getSQLstr() {
		return SQLstr;
	}
	public void setSQLstr(String sQLstr) {
		SQLstr = sQLstr;
	}
	public String getStaName() {
		return staName;
	}
	public void setStaName(String staName) {
		this.staName = staName;
	}
	public String getStaUrl() {
		return staUrl;
	}
	public void setStaUrl(String staUrl) {
		this.staUrl = staUrl;
	}
}
